In this video we are going to discuss the concept of naming cells and creating named ranges named cells
and named ranges are used for referencing a particular cell or a group of cells.
So by default if you go to any cell the name of this cell is given in this name box and the name of
the cell is C. 24.
That is the column name and the rule number.
But this is the default name you can assign any name of your choice to any cell on this worksheet.
So to this c 24 cell if I want to assign the name day I can just go ahead and rename it to day.
Now if I click this cell you'll see that the name of the cell is the.
Now once we have assigned a name to the cell we can call this cell by its name anywhere.
So if you want to get the value in the C 24 said you can just write is equal to B
and hit enter.
You'll see that whatever value is in the cell name day that value will be shown here.
So this is similar to calling any cell by its name.
We can alternate is equal to be 24 to get the value in this will be 24.
So instead of using the default name we can use the name that we have assigned to any said we can do
the same thing for a range of cells also.
So for example if I selected range from B five to be 21 this range of values is representing whether
vegetables were bought on a particular day or not
so if I want to assign a name say vegetables to this range I can select this entire range go to the
name box and give it a name vegetables
now whenever you will select this entire name range you will see that it has the name vegetables.
There are two reasons why we assign name to Orange.
One is if you want to come back to this range multiple times to look at it we can do this using this
name range.
The point is when we assign a name to this range that name can be seen in the drop box it.
So whenever I click on vegetable it the entire range will be highlighted even if I'm on a different
sheet and I'm working on something else.
I can come back to the vegetable says just by clicking on the name.
So if you have to revisit that particular data multiple times you can just assign a name to that data.
And whenever you want to come back to it you can just selected from the dropdown of the name box.
The second reason is you can use that name in formulas to reference this entire range.
So for example if I want to sum the number of times we stored vegetables that is I want to sum all the
values in this selected range of sales I can use the sum formula
and within bracket and I need to specify the range of says that I want to add instead of writing be
five to be twenty one I can simply import the name that is vegetables.
This is the name for this entire range of fields and I can press into this is similar to writing some
and selecting this entire range
and in that scenario also we get the same result.
So there are two reasons why we use name ranges.
One is if we want to revisit the data again and again we can create a name and we can select that name
from the name box.
And secondly we can use the assigned name to reference that particular range of sales in our formulas.
Now the first way we discuss to assign a name to ranges that is by selecting the entire range and then
by going to the named box and giving it a name that is simple.
There is one more way which gives us a lot of flexibility.
For that we have to go to the formula stub
any formula stub.
There is an entire section on names.
You can see a big icon for Name Manager.
And there are other smaller icons for different other purposes.
If you open the Name Manager you'll see the list of all the names that you have assigned.
So we assigned a name day to one of the sales.
It is right now containing the value Monday and it refers to this in C 24 in the sheet named ranges.
Similarly we assigned a name vegetables to says B five to D 21 in this sheet.
Here you can also see three options.
One is for creating new names.
The other is to edit the names that you have already created and the third option is to delete the names
that you have created.
We'll see how to create a new name from this method also let's click on new.
Let's first give the name of the range.
Let's say baby
in the scope.
You have to mention where you are going to use this name range.
If you select workbook this name brand will work on any sheet and this workbook.
If you select this particular sheet say same name changes or sheet one.
This named range will look only in that particular sheet.
You can mentioned comments also last part is the.
Most important that we have to mention what are the range of cells it refers to.
Here we will select e five to e 21
know what it's like okay.
And you can see that a new name is added baby.
And it is referring to the change.
If I do eat 21 include this and if I go to the dropdown I can select on baby and it will highlight all
the sales in this range.
Now if we want to assign names to all columns of people if we do it one by one it might take us a lot
of pain.
So for example here in this table I have eight columns.
If I wanted to assign names to these eight columns one by one I have to again select the danger of one
column and then give it a name instead of that that is a shortcut or doing it before select all the
columns.
Along with their headers indicators we want names once we select this part we go to create from selection
option.
And here we select that in the top row.
We have the named values.
What this will do is for each column it will create a new named range and the header of that column
will be used to assign that particular need.
So if you do F twenty one will have the name fruit defined to g twenty one will have the name milk.
So let's click on okay and let us open the name manager once again to see that all these four have been
created.
Fruit milk meat and DVD and you can check the reference part also duties.
Therefore 2 8 5 2 age 21 fruit refers to if I do have 21
just keep in mind that when you are giving name through this method there should be no space indicated.
So this transaction space hash will not work.
You have to remove this space and after that you can use it to name that particular range of it.
So this is how we assign name to a single cell or a range of cells and we use the assigned name to go
back to that particular cell or range of cells or use it in formula to do calculations on those range
of cells.